package com.insurance.service;

import com.insurance.common.ResultData;
import org.apache.ibatis.annotations.Param;

import java.sql.SQLException;

/**
 * Created with IntelliJ IDEA.
 * User: 朱雄
 * Date: 2020/10/29 10:33
 * Description:
 * Version: V1.0
 */
public interface PublicCityService {
    /**
     * 查询已开通市
     * @return
     */
    ResultData queryByCity( int province_id) throws SQLException;
    /**
     * 查询省
     * @return
     */
    ResultData queryByProvinceDriver() throws SQLException ;

    /**
     * 查询区域
     */
    ResultData queryByAreaDriver(int cityId) throws SQLException ;

    /**
     * 查询未读消息
     * @return
     * @param user_id
     */
    ResultData queryunreadInformByUserId( int user_id);

    /**
     * 查询已读消息
     * @param user_id
     * @return
     */
    ResultData queryreadInformByUserId(int user_id);

    /**
     * 修改消息为已读
     * @param user_id
     * @return
     */
    ResultData readInformByUserId(int user_id);

    /**
     * 判断用户名是否重复
     * @param userName
     * @return
     */
    ResultData verificationUserName(String userName);

    /**
     * 判断用户电话是否重复
     * @param userPhone
     * @return
     */
    ResultData verificationUserPhone(String userPhone);

    ResultData verificationUserEmail(String userEmail);

    /**
     * 修改用户是判断用户名是否重复
     * @param user_id
     * @return
     */
    ResultData updateverificationUserName(Integer user_id);

    ResultData rankingDriver();

    ResultData countOrder();
}
